package com.kvest.scanrecognizer.datastorage.table;

import android.provider.BaseColumns;

/**
 * Created with IntelliJ IDEA.
 * User: Kvest
 * Date: 14.09.13
 * Time: 19:58
 * To change this template use File | Settings | File Templates.
 */
public class RecognizeItemTable implements BaseColumns {
    public static final String TABLE_NAME = "recognize_item";

    public static final String UID_COLUMN = "uid";
    public static final String STATUS_COLUMN = "status";
    public static final String SEND_DATE_COLUMN = "send_date";
    public static final String NAME_COLUMN = "name";
    public static final String FAVORITE_COLUMN = "favorite";
    public static final String THUMBNAIL_COLUMN = "thumbnail";

    public static final String[] FULL_PROJECTION = {_ID, UID_COLUMN, STATUS_COLUMN, SEND_DATE_COLUMN,
                                                    NAME_COLUMN, FAVORITE_COLUMN, THUMBNAIL_COLUMN};

    public static final String CREATE_TABLE_SQL = "CREATE TABLE \"" + TABLE_NAME + "\" (\"" +
            _ID + "\" INTEGER PRIMARY KEY AUTOINCREMENT, \"" +
            UID_COLUMN + "\" TEXT UNIQUE NOT NULL, \"" +
            STATUS_COLUMN + "\" INTEGER DEFAULT 0, \"" +
            SEND_DATE_COLUMN + "\" INTEGER DEFAULT 0, \"" +
            NAME_COLUMN + "\" TEXT DEFAULT \"\", \"" +
            FAVORITE_COLUMN + "\" INTEGER DEFAULT 0, \"" +
            THUMBNAIL_COLUMN + "\" BLOB);";

    public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS \"" + TABLE_NAME + "\";";
}
